Applications of JAVA programming language to databasemanagementBradley

1 Motivation The Java programming language 1,3] from its inception has been publicized as a web programming language. Many programmers have developed simple applications such as games, clocks, news tickers and stock tickers in order to create informative, innovative web sites. However, it is important to note that the Java programming language possesses much more capability. The language components and constructs originally designed to enhance the functional-ity of Java as a web-based programming language can be utilized in a broader extent. Java provides a developer with the tools allowing for the creation of innovative network, database, and Graphical User Interface (GUI) applications. In fact, Java and its associated technologies such as JDBC API 11,5], JDBC drivers 2,12], threading 10], and AWT provide the programmer with the much-needed assistance for the development of platform-independent database-independent interfaces. Thus, it is possible to build a graphical database interface capable of connecting and querying distributed databases 13,14]. Here are components that are important for building the database interface we have in mind. JDBC { The Java Database Connectivity module is a standardized database access solution (JDBC is packaged in Java 1.1 and later versions). Java Threads { The Java programming language is multithreaded language. It provides multiple threads, lightweight quasi-processes, handling diierent tasks at the same time. AWT { The abstract window toolkit provides the ability to build platform-independent graphical user interfaces. The combination of the above technologies provides the fundamental building blocks that we use to develop a distributed database interface. This package , Java Distributed Query Dispatcher (Java DQD), is a platform-independent GUI application capable of querying multiple heterogeneous databases simultaneously. JavaDQD is based upon the following ideas: 1. JavaDQD application establishes database con-nectivity using JDBC API and drivers. By utilizing the JDBC API, JavaDQD provides uniform access to any database providing a JDBC driver. That is, a user may connect to any database for which a JDBC driver is provided. For our purposes, we will connect to Sybase and MiniSQL using FastForward and mSQL-JDBC respectively. The mSQL-JDBC driver, we use, has been modiied to implement the desired DatabaseMetaData functionality. As other JDBC drivers are developed and become available, JavaDQD will allow for their incorporation. Thus, JavaDQD is an extendable tool for multiple database connectivity. 2. JavaDQD interface uses Java threads to allow a user to connect to multiple databases simultaneously. The user can submit query distributed over multiple databases; hence, when …